###
 # @Company: TWL
 # @Author: xue jian
 # @Email: xuejian@kanzhun.com
 # @Date: 2020-10-14 17:03:19
### 
down_file() {
    day=$1
    sql="select * from arc_five_dev.recall_sample_all where ds='$day'"
    echo $sql
    mkdir -p $day
    hive -e "${sql}" > $day/out
}

down_file $1